<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>毕业生档案管理系统 - 在校管理 </title>
    <meta name="Copyright" content="Douco Design."/>
    <link href="${pageContext.request.contextPath}/css/public.css" rel="stylesheet" type="text/css">
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery.min.js"></script>
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/global.js"></script>
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery.tab.js"></script>
</head>
<body>
<div id="dcWrap">
    <div id="dcHead">
        <div id="head">
            <div class="nav">
                <ul class="navRight">
                    <c:choose>
                        <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                            <li>
                                当前用户：${sessionScope.userInfo.basicinformationRole}:${sessionScope.userInfo.teacherName}</li>
                        </c:when>
                        <c:otherwise>
                            <li>
                                当前用户：${sessionScope.userInfo.basicinformationRole}:${sessionScope.userInfo.basicinformationName}</li>
                        </c:otherwise>
                    </c:choose>
                    <li class="noRight"><a href="${pageContext.request.contextPath}/login/loginOut.action">退出</a></li>
                </ul>
            </div>
        </div>
    </div>
</div>
<!-- dcHead 结束 -->
<div id="dcLeft">
    <div id="menu">
        <ul class="top">
            <li><a href="${pageContext.request.contextPath}/index.jsp"><i class="home"></i><em>管理首页</em></a></li>
        </ul>
        <ul>
            <c:choose>
                <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 1}">
                    <li><a href="${pageContext.request.contextPath }/basicinformation/selectLimit.action">
                        <i class="system"></i><em>新生档案管理</em></a>
                    </li>
                </c:when>
                <c:when test="${sessionScope.userInfo.basicinformationRole=='学生'}">
                    <li><a href="${pageContext.request.contextPath }/basicinformation/selectLimit.action"><i
                            class="system"></i><em>新生档案管理</em></a></li>
                </c:when>
            </c:choose>
            <c:choose>
                <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                    <li class="cur"><a href="${pageContext.request.contextPath}/achievement/selectLimit.action">
                        <i class="nav"></i><em>在校管理</em></a></li>
                </c:when>
                <c:otherwise>
                    <li class="cur"><a href="${pageContext.request.contextPath}/achievement/selectLimitStu.action">
                        <i class="nav"></i><em>在校管理</em></a></li>
                </c:otherwise>
            </c:choose>
            <c:choose>
                <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 1}">
                    <li><a href="${pageContext.request.contextPath }/graduation/selectLimit.action"><i
                            class="show"></i><em>毕业管理</em></a></li>
                </c:when>
                <c:when test="${sessionScope.userInfo.basicinformationRole=='学生'}">
                    <li><a href="${pageContext.request.contextPath }/graduation/selectLimitStu.action"><i
                            class="show"></i><em>毕业管理</em></a></li>
                </c:when>
            </c:choose>
        </ul>
    </div>
</div>


<div id="dcMain">
    <!-- 当前位置 -->
    <div id="urHere">毕业生档案管理系统<b>></b><strong>在校管理</strong></div>
    <div class="mainBox" style="height:auto!important;height:550px;min-height:550px;">
        <h3>在校管理</h3>
        <script type="text/javascript">
            $(function () {
                $(".idTabs").idTabs();
            });

        </script>
        <div class="idTabs">
            <ul class="tab">
                <c:choose>
                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 1}">
                        <li><a href="#Achievement">成绩表</a></li>
                        <li><a href="#Reward">获奖情况</a></li>
                        <li><a href="#Certificate">获得证书</a></li>
                        <li><a href="#Punish">获得处分信息</a></li>
                    </c:when>
                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 0}">
                        <li><a href="#Achievement">成绩表</a></li>
                    </c:when>
                    <c:otherwise>
                        <li><a href="#Achievement">成绩表</a></li>
                        <li><a href="#Reward">获奖情况</a></li>
                        <li><a href="#Certificate">获得证书</a></li>
                    </c:otherwise>
                </c:choose>
            </ul>
            <div class="items">
                <c:choose>
                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 1}">
                        <!-- 成绩表 -->
                        <div id="Achievement">
                            <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                <form action="${pageContext.request.contextPath}/achievement/selectLimit.action" method="post"
                                      enctype="multipart/form-data">
                                    <tr>
                                        <c:choose>
                                            <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                                <td>
                                                    <!--学生选学年-->
                                                    <select name="keywordTime">
                                                        <option value="">入学以来</option>
                                                        <c:forEach items="${applicationScope.courseYear}" var="courseYear">
                                                            <option value="<fmt:formatDate value='${courseYear.courseYear}' pattern='yyyy-MM-dd'/>">
                                                                <fmt:formatDate value="${courseYear.courseYear}"
                                                                                pattern="yyyy-MM-dd"/>
                                                            </option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <!--老师选择-->
                                                    <select name="keywordCouse">
                                                        <option value="">所有课程</option>
                                                        <c:forEach items="${applicationScope.courseList}" var="course">
                                                            <option value="${course.courseCoursename}">${course.courseCoursename}</option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <select name="keywordClass">
                                                        <option value="">所有班级</option>
                                                        <option value="软件工程">软件工程</option>
                                                        <option value="计算机科学与技术">计算机科学与技术</option>
                                                        <option value="信息科学与技术">信息科学与技术</option>
                                                        <option value="网络工程">网络工程</option>
                                                        <option value="大数据">大数据</option>
                                                    </select>
                                                </td>
                                                <td colspan="6" align="right">
                                                    <input type="text" name="keywordName" title="请输入姓名"/>
                                                </td>
                                                <td><input type="submit" value="搜索"/></td>
                                            </c:when>
                                        </c:choose>

                                    </tr>
                                </form>


                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <form action="${pageContext.request.contextPath}/achievement/selectExport.action"
                                              method="post">
                                            <input type="hidden" name="keywordTime"
                                                   value="<fmt:formatDate value='${achievementPage.paramEntity.course.courseYear}' pattern='yyyy-MM-dd'/>">
                                            <input type="hidden" name="keywordCouse"
                                                   value="${achievementPage.paramEntity.course.courseCoursename}">
                                            <input type="hidden" name="keywordClass"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationClass}">
                                            <input type="hidden" name="keywordName"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationName}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:when>
                                    <c:otherwise>
                                        <form action="${pageContext.request.contextPath}/achievement/selectExportStu.action"
                                              method="post">
                                            <input type="hidden" name="keywordBasicinformationId"
                                                   value="${sessionScope.userInfo.basicinformationId}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:otherwise>
                                </c:choose>


                                <tr>
                                    <th width="20">序号</th>
                                    <th>姓名</th>
                                    <th>学号</th>
                                    <th>院系</th>
                                    <th>专业班级</th>
                                    <th>课程代号</th>
                                    <th>课程名</th>
                                    <th>课程类别</th>
                                    <th>学分</th>
                                    <th>成绩</th>
                                    <th>教师</th>
                                </tr>
                                <c:forEach items="${achievementPage.list}" var="list" varStatus="pageIndex">
                                    <tr>
                                        <td>${pageIndex.count}</td>
                                        <td>${list.basicinformation.basicinformationName}</td>
                                        <td>${list.basicinformation.basicinformationId}</td>
                                        <td>${list.institute.instituteName}</td>
                                        <td>${list.basicinformation.basicinformationClass}</td>
                                        <td>${list.course.courseCoursenume}</td>
                                        <td>${list.course.courseCoursename}</td>
                                        <c:choose>
                                            <c:when test="${list.course.courseCategory  == 1}">
                                                <td>必修</td>
                                            </c:when>
                                            <c:otherwise>
                                                <td>选修</td>
                                            </c:otherwise>
                                        </c:choose>
                                        <td>${list.course.courseCredit}</td>
                                        <td>${list.achievementGrade}</td>
                                        <td>${list.teacher.teacherName}</td>
                                    </tr>
                                </c:forEach>
                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:when>
                                    <c:otherwise>
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:otherwise>
                                </c:choose>

                            </table>
                            <br/>
                            <br/>
                            <br/>
                            <form action="${pageContext.request.contextPath}/achievement/insertExcel.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <td align="right" width="20">学生成绩表</td>
                                        <td>
                                            <input type="file" name="score" size="18"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                        </td>
                                        <div style="color:red;width: 100%;text-align: center">${messageAchievement}</div>
                                    </tr>
                                </table>
                            </form>
                        </div>

                        <!--获奖情况-->

                        <div id="Reward">
                            <form action="${pageContext.request.contextPath}/reward/insert.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <th width="131">名称</th>
                                        <th>内容</th>
                                    </tr>
                                    <tr>
                                        <td align="right">学号</td>
                                        <td>
                                            <input type="text" name="basicinformationId" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">获奖名称</td>
                                        <td>
                                            <input type="text" name="rewardRename" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right"> 奖项级别</td>
                                        <td>
                                            <select name="rewardLevel">
                                                <option value="院级">院级</option>
                                                <option value="校级">校级</option>
                                                <option value="市级">市级</option>
                                                <option value="省级">省级</option>
                                                <option value="国家级">国家级</option>
                                            </select>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">颁发单位</td>
                                        <td>
                                            <input type="text" name="rewardUnit" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">颁发时期</td>
                                        <td>
                                            <input type="date" name="rewardDate" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">奖项图片</td>
                                        <td>
                                            <input type="file" name="pic" size="18"/>
                                        </td>
                                    </tr>


                                    <tr>
                                        <td align="right">辅导员审核</td>
                                        <td>
                                            <input type="radio" name="rewardCheck" id="judge" value="1"/>通过
                                            <input type="radio" name="rewardCheck" id="judges" value="0"/>不通过
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                            <div style="color:red;">${requestScope.message}</div>
                                        </td>

                                    </tr>


                                </table>
                            </form>
                        </div>
                        <!--获得证书-->
                        <div id="Certificate">
                            <form action="${pageContext.request.contextPath}/certificate/insert.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <td align="right">学号</td>
                                        <td>
                                            <input type="text" name="basicinformationId" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">证书名称</td>
                                        <td>
                                            <input type="text" name="certificateCername" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">证书图片</td>
                                        <td>
                                            <input type="file" name="pic" size="18"/>
                                        </td>

                                    </tr>
                                    <tr>
                                        <td align="right">颁发日期</td>
                                        <td>
                                            <input type="date" name="certificateDate" size="80" class="inpMain"/>
                                        </td>

                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                            <div style="color:red;">${requestScope.messageCertificate}</div>
                                        </td>

                                    </tr>


                                </table>
                            </form>
                        </div>

                        <!--获得处分信息-->
                        <div id="Punish">
                            <form action="${pageContext.request.contextPath}/punish/insert.action" method="post"
                                  enctype="multipart/form-data">

                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <th width="131">名称</th>
                                        <th>内容</th>
                                    </tr>
                                    <tr>
                                        <td align="right">学号</td>
                                        <td>
                                            <input type="text" name="basicinformationId" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">处分级别</td>
                                        <td>
                                            <label>
                                                <select name="punishLevel">
                                                    <option value="warn">警告</option>
                                                    <option value="seriousWarning">严重警告</option>
                                                    <option value="schoolWatch">留校查看</option>
                                                    <option value="expel">开除</option>
                                                </select>
                                            </label>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">下处分的单位</td>
                                        <td>
                                            <input type="text" name="punishUnit" value="" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">处分开始日期</td>
                                        <td>
                                            <input type="date" name="punishBegindate" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">处分结束日期</td>
                                        <td>
                                            <input type="date" name="punishEnddate" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">处分文件</td>
                                        <td>
                                            <input type="file" name="pic" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">撤销时间</td>
                                        <td>
                                            <input type="date" name="punishCancel" value="" size="80" class="inpMain"/>
                                        </td>
                                    </tr>

                                    <tr>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                        </td>
                                        <td>
                                            <div style="color:red;">${requestScope.messagePunish}</div>
                                        </td>

                                    </tr>

                                </table>
                            </form>
                        </div>
                    </c:when>
                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师' && sessionScope.userInfo.teacherType eq 0}">
                        <!-- 成绩表 -->
                        <div id="Achievement">
                            <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                <form action="${pageContext.request.contextPath}/achievement/selectLimit.action" method="post"
                                      enctype="multipart/form-data">
                                    <tr>
                                        <c:choose>
                                            <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                                <td>
                                                    <!--学生选学年-->
                                                    <select name="keywordTime">
                                                        <option value="">入学以来</option>
                                                        <c:forEach items="${applicationScope.courseYear}" var="courseYear">
                                                            <option value="<fmt:formatDate value='${courseYear.courseYear}' pattern='yyyy-MM-dd'/>">
                                                                <fmt:formatDate value="${courseYear.courseYear}"
                                                                                pattern="yyyy-MM-dd"/>
                                                            </option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <!--老师选择-->
                                                    <select name="keywordCouse">
                                                        <option value="">所有课程</option>
                                                        <c:forEach items="${applicationScope.courseList}" var="course">
                                                            <option value="${course.courseCoursename}">${course.courseCoursename}</option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <select name="keywordClass">
                                                        <option value="">所有班级</option>
                                                        <option value="软件工程">软件工程</option>
                                                        <option value="计算机科学与技术">计算机科学与技术</option>
                                                        <option value="信息科学与技术">信息科学与技术</option>
                                                        <option value="网络工程">网络工程</option>
                                                        <option value="大数据">大数据</option>
                                                    </select>
                                                </td>
                                                <td colspan="6" align="right">
                                                    <input type="text" name="keywordName" title="请输入姓名"/>
                                                </td>
                                                <td><input type="submit" value="搜索"/></td>
                                            </c:when>
                                        </c:choose>

                                    </tr>
                                </form>


                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <form action="${pageContext.request.contextPath}/achievement/selectExport.action"
                                              method="post">
                                            <input type="hidden" name="keywordTime"
                                                   value="<fmt:formatDate value='${achievementPage.paramEntity.course.courseYear}' pattern='yyyy-MM-dd'/>">
                                            <input type="hidden" name="keywordCouse"
                                                   value="${achievementPage.paramEntity.course.courseCoursename}">
                                            <input type="hidden" name="keywordClass"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationClass}">
                                            <input type="hidden" name="keywordName"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationName}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:when>
                                    <c:otherwise>
                                        <form action="${pageContext.request.contextPath}/achievement/selectExportStu.action"
                                              method="post">
                                            <input type="hidden" name="keywordBasicinformationId"
                                                   value="${sessionScope.userInfo.basicinformationId}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:otherwise>
                                </c:choose>


                                <tr>
                                    <th width="20">序号</th>
                                    <th>姓名</th>
                                    <th>学号</th>
                                    <th>院系</th>
                                    <th>专业班级</th>
                                    <th>课程代号</th>
                                    <th>课程名</th>
                                    <th>课程类别</th>
                                    <th>学分</th>
                                    <th>成绩</th>
                                    <th>教师</th>
                                </tr>
                                <c:forEach items="${achievementPage.list}" var="list" varStatus="pageIndex">
                                    <tr>
                                        <td>${pageIndex.count}</td>
                                        <td>${list.basicinformation.basicinformationName}</td>
                                        <td>${list.basicinformation.basicinformationId}</td>
                                        <td>${list.institute.instituteName}</td>
                                        <td>${list.basicinformation.basicinformationClass}</td>
                                        <td>${list.course.courseCoursenume}</td>
                                        <td>${list.course.courseCoursename}</td>
                                        <c:choose>
                                            <c:when test="${list.course.courseCategory  == 1}">
                                                <td>必修</td>
                                            </c:when>
                                            <c:otherwise>
                                                <td>选修</td>
                                            </c:otherwise>
                                        </c:choose>
                                        <td>${list.course.courseCredit}</td>
                                        <td>${list.achievementGrade}</td>
                                        <td>${list.teacher.teacherName}</td>
                                    </tr>
                                </c:forEach>
                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:when>
                                    <c:otherwise>
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:otherwise>
                                </c:choose>

                            </table>
                            <br/>
                            <br/>
                            <br/>
                            <form action="${pageContext.request.contextPath}/achievement/insertExcel.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <td align="right" width="20">学生成绩表</td>
                                        <td>
                                            <input type="file" name="score" size="18"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                        </td>
                                        <div style="color:red;width: 100%;text-align: center">${messageAchievement}</div>
                                    </tr>
                                </table>
                            </form>
                        </div>
                    </c:when>
                    <c:otherwise>
                        <!-- 成绩表 -->
                        <div id="Achievement">
                            <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                <form action="${pageContext.request.contextPath}/achievement/selectLimit.action" method="post"
                                      enctype="multipart/form-data">
                                    <tr>
                                        <c:choose>
                                            <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                                <td>
                                                    <!--学生选学年-->
                                                    <select name="keywordTime">
                                                        <option value="">入学以来</option>
                                                        <c:forEach items="${applicationScope.courseYear}" var="courseYear">
                                                            <option value="<fmt:formatDate value='${courseYear.courseYear}' pattern='yyyy-MM-dd'/>">
                                                                <fmt:formatDate value="${courseYear.courseYear}"
                                                                                pattern="yyyy-MM-dd"/>
                                                            </option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <!--老师选择-->
                                                    <select name="keywordCouse">
                                                        <option value="">所有课程</option>
                                                        <c:forEach items="${applicationScope.courseList}" var="course">
                                                            <option value="${course.courseCoursename}">${course.courseCoursename}</option>
                                                        </c:forEach>
                                                    </select>
                                                </td>
                                                <td>
                                                    <select name="keywordClass">
                                                        <option value="">所有班级</option>
                                                        <option value="软件工程">软件工程</option>
                                                        <option value="计算机科学与技术">计算机科学与技术</option>
                                                        <option value="信息科学与技术">信息科学与技术</option>
                                                        <option value="网络工程">网络工程</option>
                                                        <option value="大数据">大数据</option>
                                                    </select>
                                                </td>
                                                <td colspan="6" align="right">
                                                    <input type="text" name="keywordName" title="请输入姓名"/>
                                                </td>
                                                <td><input type="submit" value="搜索"/></td>
                                            </c:when>
                                        </c:choose>

                                    </tr>
                                </form>


                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <form action="${pageContext.request.contextPath}/achievement/selectExport.action"
                                              method="post">
                                            <input type="hidden" name="keywordTime"
                                                   value="<fmt:formatDate value='${achievementPage.paramEntity.course.courseYear}' pattern='yyyy-MM-dd'/>">
                                            <input type="hidden" name="keywordCouse"
                                                   value="${achievementPage.paramEntity.course.courseCoursename}">
                                            <input type="hidden" name="keywordClass"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationClass}">
                                            <input type="hidden" name="keywordName"
                                                   value="${achievementPage.paramEntity.basicinformation.basicinformationName}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:when>
                                    <c:otherwise>
                                        <form action="${pageContext.request.contextPath}/achievement/selectExportStu.action"
                                              method="post">
                                            <input type="hidden" name="keywordBasicinformationId"
                                                   value="${sessionScope.userInfo.basicinformationId}">
                                            <tr>
                                                <td>
                                                    <input class="btn" type="submit" value="导出成绩"/>
                                                </td>

                                            </tr>
                                        </form>
                                    </c:otherwise>
                                </c:choose>


                                <tr>
                                    <th width="20">序号</th>
                                    <th>姓名</th>
                                    <th>学号</th>
                                    <th>院系</th>
                                    <th>专业班级</th>
                                    <th>课程代号</th>
                                    <th>课程名</th>
                                    <th>课程类别</th>
                                    <th>学分</th>
                                    <th>成绩</th>
                                    <th>教师</th>
                                </tr>
                                <c:forEach items="${achievementPage.list}" var="list" varStatus="pageIndex">
                                    <tr>
                                        <td>${pageIndex.count}</td>
                                        <td>${list.basicinformation.basicinformationName}</td>
                                        <td>${list.basicinformation.basicinformationId}</td>
                                        <td>${list.institute.instituteName}</td>
                                        <td>${list.basicinformation.basicinformationClass}</td>
                                        <td>${list.course.courseCoursenume}</td>
                                        <td>${list.course.courseCoursename}</td>
                                        <c:choose>
                                            <c:when test="${list.course.courseCategory  == 1}">
                                                <td>必修</td>
                                            </c:when>
                                            <c:otherwise>
                                                <td>选修</td>
                                            </c:otherwise>
                                        </c:choose>
                                        <td>${list.course.courseCredit}</td>
                                        <td>${list.achievementGrade}</td>
                                        <td>${list.teacher.teacherName}</td>
                                    </tr>
                                </c:forEach>
                                <c:choose>
                                    <c:when test="${sessionScope.userInfo.basicinformationRole=='教师'}">
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimit.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:when>
                                    <c:otherwise>
                                        <tr>
                                            <td colspan="13" align="center">
                                                第${achievementPage.pageIndex }/${achievementPage.pageCount }页 &nbsp;&nbsp;
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=1">首页</a>
                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex > 1}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex - 1}">上一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        上一页
                                                    </c:otherwise>
                                                </c:choose>

                                                <c:choose>
                                                    <c:when test="${achievementPage.pageIndex  < achievementPage.pageCount}">
                                                        <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageIndex + 1}">下一页</a>
                                                    </c:when>
                                                    <c:otherwise>
                                                        下一页
                                                    </c:otherwise>
                                                </c:choose>
                                                <a href="${pageContext.request.contextPath }/achievement/selectLimitStu.action?pageIndex=${achievementPage.pageCount}">尾页</a>
                                            </td>
                                        </tr>
                                    </c:otherwise>
                                </c:choose>

                            </table>
                            <br/>
                            <br/>
                            <br/>
                            <form action="${pageContext.request.contextPath}/achievement/insertExcel.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <td align="right" width="20">学生成绩表</td>
                                        <td>
                                            <input type="file" name="score" size="18"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                        </td>
                                        <div style="color:red;width: 100%;text-align: center">${messageAchievement}</div>
                                    </tr>
                                </table>
                            </form>
                        </div>


                        <!--获奖情况-->

                        <div id="Reward">
                            <form action="${pageContext.request.contextPath}/reward/insert.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <th width="131">名称</th>
                                        <th>内容</th>
                                    </tr>
                                    <tr>
                                        <td align="right">学号</td>
                                        <td>
                                            <input type="text" name="basicinformationId" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">获奖名称</td>
                                        <td>
                                            <input type="text" name="rewardRename" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right"> 奖项级别</td>
                                        <td>
                                            <select name="rewardLevel">
                                                <option value="院级">院级</option>
                                                <option value="校级">校级</option>
                                                <option value="市级">市级</option>
                                                <option value="省级">省级</option>
                                                <option value="国家级">国家级</option>
                                            </select>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">颁发单位</td>
                                        <td>
                                            <input type="text" name="rewardUnit" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">颁发时期</td>
                                        <td>
                                            <input type="date" name="rewardDate" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">奖项图片</td>
                                        <td>
                                            <input type="file" name="pic" size="18"/>
                                        </td>
                                    </tr>


                                    <tr>
                                        <td align="right">辅导员审核</td>
                                        <td>
                                            <input type="radio" name="rewardCheck" id="judge" value="1"/>通过
                                            <input type="radio" name="rewardCheck" id="judges" value="0"/>不通过
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                            <div style="color:red;">${requestScope.message}</div>
                                        </td>

                                    </tr>


                                </table>
                            </form>
                        </div>
                        <!--获得证书-->
                        <div id="Certificate">
                            <form action="${pageContext.request.contextPath}/certificate/insert.action" method="post"
                                  enctype="multipart/form-data">
                                <table width="100%" border="0" cellpadding="8" cellspacing="0" class="tableBasic">
                                    <tr>
                                        <td align="right">学号</td>
                                        <td>
                                            <input type="text" name="basicinformationId" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">证书名称</td>
                                        <td>
                                            <input type="text" name="certificateCername" size="80" class="inpMain"/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right">证书图片</td>
                                        <td>
                                            <input type="file" name="pic" size="18"/>
                                        </td>

                                    </tr>
                                    <tr>
                                        <td align="right">颁发日期</td>
                                        <td>
                                            <input type="date" name="certificateDate" size="80" class="inpMain"/>
                                        </td>

                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <input name="submit" class="btn" type="submit" value="提交"/>
                                            <div style="color:red;">${requestScope.messageCertificate}</div>
                                        </td>

                                    </tr>


                                </table>
                            </form>
                        </div>
                    </c:otherwise>
                </c:choose>
            </div>
        </div>
    </div>

</div>
<div class="clear"></div>
</body>
</html>